SELECT * FROM T_UWWTPS WHERE uwwState=1 AND uwwCode NOT IN (SELECT uwwCode FROM T_DischargePoints)

---